package com.WISSC.mapper;

import com.WISSC.bean.Occupation;
import com.WISSC.bean.Student;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import io.swagger.models.auth.In;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 职业资格信息表 Mapper 接口
 * </p>
 *
 * @author 张凯
 * @since 2019-05-06
 */
public interface OccupationMapper extends BaseMapper<Occupation> {

    /**
     *
     * @param map
     * @return 查询 + 分页
     */
    List<Occupation> selectOccupation(@Param("map") Map map);
    Integer countOccupation(@Param("map") Map map);
    /**
     * @param map
     * @return 资格证书登陆
     */
    List<Occupation> login(@Param("map")Map map);
    /**
     * @param idNumber
     * @return 判断该用户是否存在对应的资格证书
     */
    Occupation getOccupationNull(@Param("idNumber")String idNumber, @Param("id") Integer id);


    /**
     * @param
     * @return 个人赛事 资格证书查询
     */
    Occupation list(@Param("idNumber")String idNumber);

    List<Occupation> getOccupationCity(@Param("id")Long id);

    Occupation countPerson();

    List<Occupation> getOccupation(@Param("map") Map map);

    Occupation getOccupationByidNo(@Param("idNo")String idNo);

    /**
     *
     * @param idNumber
     * @param qualifications
     * @return 获取对应资格证书的数量
     */
    int getCount(@Param("idNumber") String idNumber,@Param("qualifications") Integer qualifications);

    int getOccupationCount(@Param("idNumber")String idNumber);

    Occupation getIdNumber(@Param("idNo")String idNo);

    List<Occupation> getOccupation1(@Param("map")Map map);
}
